home *** CD-ROM | disk | FTP | other *** search
/ Developer CD Series 1997 April: Mac OS SDK / Dev.CD Apr 97 SDK1.toast / Development Kits (Disc 1) / AppleScript / Goodies / Scripting Additions / Data Access Manager / Read Me < prev    next >
Unknown  |  1993-12-08  |  2.0 KB  |  [QUIL/quil]

open in: MacOS 8.1     |     Win98     |     DOS

view JSON data     |     view as text


This file was not able to be converted.
This format is not currently supported by dexvert.

ConfidenceProgramDetectionMatch TypeSupport
100% file data default


id metadata
keyvalue
macFileType[QUIL]
macFileCreator[quil]



hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 07 00 00 07 08 04 44 | 2e 41 2e 4d 2e 20 41 63 |.......D|.A.M. Ac|
|00000010| 63 65 73 73 0d 0d 54 68 | 69 73 20 53 63 72 69 70 |cess..Th|is Scrip|
|00000020| 74 69 6e 67 20 41 64 64 | 69 74 69 6f 6e 20 75 73 |ting Add|ition us|
|00000030| 65 73 20 64 61 74 61 20 | 61 63 63 65 73 73 20 73 |es data |access s|
|00000040| 6f 66 74 77 61 72 65 20 | 66 72 6f 6d 20 41 70 70 |oftware |from App|
|00000050| 6c 65 20 2d 2d 20 63 61 | 6c 6c 65 64 20 44 61 74 |le -- ca|lled Dat|
|00000060| 61 20 41 63 63 65 73 73 | 20 4d 61 6e 61 67 65 72 |a Access| Manager|
|00000070| 2c 20 6f 72 20 44 41 4d | 2c 20 74 6f 20 61 75 74 |, or DAM|, to aut|
|00000080| 6f 6d 61 74 69 63 61 6c | 6c 79 20 70 65 72 66 6f |omatical|ly perfo|
|00000090| 72 6d 20 71 75 65 72 69 | 65 73 20 74 6f 20 72 65 |rm queri|es to re|
|000000a0| 74 72 69 65 76 65 20 64 | 61 74 61 20 66 72 6f 6d |trieve d|ata from|
|000000b0| 20 64 61 74 61 62 61 73 | 65 73 20 6f 6e 20 68 65 | databas|es on he|
|000000c0| 74 65 72 6f 67 65 6e 65 | 6f 75 73 20 70 6c 61 74 |terogene|ous plat|
|000000d0| 66 6f 72 6d 73 2e 20 20 | 57 68 65 6e 20 75 73 65 |forms. |When use|
|000000e0| 64 20 69 6e 20 63 6f 6e | 6a 75 6e 63 74 69 6f 6e |d in con|junction|
|000000f0| 20 77 69 74 68 20 44 61 | 74 61 20 41 63 63 65 73 | with Da|ta Acces|
|00000100| 73 20 4c 61 6e 67 75 61 | 67 65 20 28 44 41 4c 29 |s Langua|ge (DAL)|
|00000110| 20 66 72 6f 6d 20 41 70 | 70 6c 65 2c 20 74 68 69 | from Ap|ple, thi|
|00000120| 73 20 63 61 6e 20 67 69 | 76 65 20 79 6f 75 20 61 |s can gi|ve you a|
|00000130| 63 63 65 73 73 20 74 6f | 20 6d 61 6e 79 20 72 65 |ccess to| many re|
|00000140| 6c 61 74 69 6f 6e 61 6c | 20 64 61 74 61 62 61 73 |lational| databas|
|00000150| 65 73 2e 20 20 54 68 69 | 73 20 61 64 64 69 74 69 |es. Thi|s additi|
|00000160| 6f 6e 20 75 73 65 73 20 | 68 69 67 68 2d 6c 65 76 |on uses |high-lev|
|00000170| 65 6c 20 44 41 4d 20 61 | 6e 64 20 71 75 65 72 79 |el DAM a|nd query|
|00000180| 20 64 6f 63 75 6d 65 6e | 74 73 20 28 64 65 73 63 | documen|ts (desc|
|00000190| 72 69 62 65 64 20 69 6e | 20 49 6e 73 69 64 65 20 |ribed in| Inside |
|000001a0| 4d 61 63 69 6e 74 6f 73 | 68 2c 20 56 6f 6c 75 6d |Macintos|h, Volum|
|000001b0| 65 20 56 49 29 20 74 6f | 20 61 63 63 6f 6d 70 6c |e VI) to| accompl|
|000001c0| 69 73 68 20 74 68 69 73 | 2e 0d 0d 49 6e 20 6f 72 |ish this|...In or|
|000001d0| 64 65 72 20 74 6f 20 75 | 73 65 20 74 68 69 73 20 |der to u|se this |
|000001e0| 61 64 64 69 74 69 6f 6e | 2c 20 79 6f 75 20 6d 75 |addition|, you mu|
|000001f0| 73 74 20 68 61 76 65 20 | 61 20 64 61 74 61 62 61 |st have |a databa|
|00000200| 73 65 20 65 78 74 65 6e | 73 69 6f 6e 2c 20 73 75 |se exten|sion, su|
|00000210| 63 68 20 61 73 20 44 41 | 4c 2c 20 69 6e 73 74 61 |ch as DA|L, insta|
|00000220| 6c 6c 65 64 20 6f 6e 20 | 79 6f 75 72 20 73 79 73 |lled on |your sys|
|00000230| 74 65 6d 2e 20 20 0d 0d | 41 6c 74 68 6f 75 67 68 |tem. ..|Although|
|00000240| 20 74 68 69 73 20 73 63 | 72 69 70 74 69 6e 67 20 | this sc|ripting |
|00000250| 61 64 64 69 74 69 6f 6e | 20 68 61 73 20 62 65 65 |addition| has bee|
|00000260| 6e 20 74 65 73 74 65 64 | 20 62 79 20 74 68 65 20 |n tested| by the |
|00000270| 61 75 74 68 6f 72 2c 20 | 74 68 69 73 20 63 6f 64 |author, |this cod|
|00000280| 65 20 68 61 73 20 6e 6f | 74 20 62 65 65 6e 20 65 |e has no|t been e|
|00000290| 78 74 65 6e 73 69 76 65 | 6c 79 20 74 65 73 74 65 |xtensive|ly teste|
|000002a0| 64 2e 20 20 54 68 69 73 | 20 69 73 20 4e 4f 54 20 |d. This| is NOT |
|000002b0| 74 6f 20 62 65 20 63 6f | 6e 73 69 64 65 72 65 64 |to be co|nsidered|
|000002c0| 20 74 68 65 20 66 69 6e | 61 6c 20 6f 72 20 62 65 | the fin|al or be|
|000002d0| 73 74 20 77 61 79 20 74 | 6f 20 75 73 65 20 44 41 |st way t|o use DA|
|000002e0| 4d 20 6f 72 20 44 41 4c | 20 66 72 6f 6d 20 41 70 |M or DAL| from Ap|
|000002f0| 70 6c 65 53 63 72 69 70 | 74 2e 20 20 49 74 20 69 |pleScrip|t. It i|
|00000300| 73 20 69 6e 74 65 6e 64 | 65 64 20 70 72 69 6d 61 |s intend|ed prima|
|00000310| 72 69 6c 79 20 61 73 20 | 61 6e 20 65 78 61 6d 70 |rily as |an examp|
|00000320| 6c 65 2e 20 20 54 68 69 | 73 20 69 73 20 50 52 4f |le. Thi|s is PRO|
|00000330| 54 4f 54 59 50 45 20 73 | 6f 66 74 77 61 72 65 20 |TOTYPE s|oftware |
|00000340| 61 6e 64 20 69 73 20 6e | 6f 74 20 66 6f 72 6d 61 |and is n|ot forma|
|00000350| 6c 6c 79 20 73 75 70 70 | 6f 72 74 65 64 20 62 79 |lly supp|orted by|
|00000360| 20 41 70 70 6c 65 20 43 | 6f 6d 70 75 74 65 72 2e | Apple C|omputer.|
|00000370| 0d 0d 54 6f 20 75 73 65 | 20 74 68 69 73 20 73 63 |..To use| this sc|
|00000380| 72 69 70 74 69 6e 67 20 | 61 64 64 69 74 69 6f 6e |ripting |addition|
|00000390| 2c 20 73 69 6d 70 6c 79 | 20 62 75 69 6c 64 20 61 |, simply| build a|
|000003a0| 20 71 75 65 72 79 20 64 | 6f 63 75 6d 65 6e 74 20 | query d|ocument |
|000003b0| 75 73 69 6e 67 20 61 20 | 74 6f 6f 6c 20 74 68 61 |using a |tool tha|
|000003c0| 74 20 65 6e 61 62 6c 65 | 73 20 74 68 69 73 20 28 |t enable|s this (|
|000003d0| 65 2e 67 2e 2c 20 42 72 | 69 6f 27 73 20 44 61 74 |e.g., Br|io's Dat|
|000003e0| 61 50 72 69 73 6d 20 6f | 72 20 43 6c 65 61 72 41 |aPrism o|r ClearA|
|000003f0| 63 63 65 73 73 20 43 6f | 72 70 6f 72 61 74 69 6f |ccess Co|rporatio|
|00000400| 6e 27 73 20 43 6c 65 61 | 72 41 63 63 65 73 73 29 |n's Clea|rAccess)|
|00000410| 2c 20 6f 72 20 62 79 20 | 75 73 69 6e 67 20 52 65 |, or by |using Re|
|00000420| 73 45 64 69 74 2e 20 20 | 51 75 65 72 79 20 64 6f |sEdit. |Query do|
|00000430| 63 75 6d 65 6e 74 73 20 | 61 6e 64 20 44 61 74 61 |cuments |and Data|
|00000440| 20 41 63 63 65 73 73 20 | 4d 61 6e 61 67 65 72 20 | Access |Manager |
|00000450| 61 72 65 20 64 65 73 63 | 72 69 62 65 64 20 69 6e |are desc|ribed in|
|00000460| 20 20 49 6e 73 69 64 65 | 20 4d 61 63 69 6e 74 6f | Inside| Macinto|
|00000470| 73 68 2c 20 56 6f 6c 75 | 6d 65 20 56 49 2e 20 20 |sh, Volu|me VI. |
|00000480| 20 49 66 20 61 20 70 61 | 74 68 20 74 6f 20 74 68 | If a pa|th to th|
|00000490| 69 73 20 71 75 65 72 79 | 20 64 6f 63 75 6d 65 6e |is query| documen|
|000004a0| 74 20 69 73 20 6e 6f 74 | 20 73 70 65 63 69 66 69 |t is not| specifi|
|000004b0| 65 64 20 69 6e 20 79 6f | 75 72 20 73 63 72 69 70 |ed in yo|ur scrip|
|000004c0| 74 2c 20 74 68 65 20 73 | 63 72 69 70 74 69 6e 67 |t, the s|cripting|
|000004d0| 20 61 64 64 69 74 69 6f | 6e 20 77 69 6c 6c 20 70 | additio|n will p|
|000004e0| 72 65 73 65 6e 74 20 61 | 20 73 74 61 6e 64 61 72 |resent a| standar|
|000004f0| 64 20 66 69 6c 65 20 64 | 69 61 6c 6f 67 20 74 6f |d file d|ialog to|
|00000500| 20 65 6e 61 62 6c 65 20 | 74 68 65 20 75 73 65 72 | enable |the user|
|00000510| 20 74 6f 20 66 69 6e 64 | 20 74 68 65 20 71 75 65 | to find| the que|
|00000520| 72 79 20 64 6f 63 75 6d | 65 6e 74 2e 20 20 20 54 |ry docum|ent. T|
|00000530| 68 69 73 20 73 63 72 69 | 70 74 69 6e 67 20 61 64 |his scri|pting ad|
|00000540| 64 69 74 69 6f 6e 20 61 | 75 74 6f 6d 61 74 69 63 |dition a|utomatic|
|00000550| 61 6c 6c 79 20 63 6f 6e | 76 65 72 74 73 20 61 6c |ally con|verts al|
|00000560| 6c 20 72 65 74 75 72 6e | 65 64 20 64 61 74 61 20 |l return|ed data |
|00000570| 74 6f 20 74 65 78 74 2c | 20 61 6e 64 20 72 65 74 |to text,| and ret|
|00000580| 75 72 6e 73 20 69 74 20 | 69 6e 20 61 20 73 69 6e |urns it |in a sin|
|00000590| 67 6c 65 20 6f 62 6a 65 | 63 74 2e 20 0d 0d 49 6e |gle obje|ct. ..In|
|000005a0| 20 6f 72 64 65 72 20 74 | 6f 20 63 6c 61 72 69 66 | order t|o clarif|
|000005b0| 79 20 75 73 61 67 65 20 | 6f 66 20 74 68 69 73 20 |y usage |of this |
|000005c0| 73 63 72 69 70 74 69 6e | 67 20 61 64 64 69 74 69 |scriptin|g additi|
|000005d0| 6f 6e 2c 20 49 20 68 61 | 76 65 20 69 6e 63 6c 75 |on, I ha|ve inclu|
|000005e0| 64 65 64 20 61 20 73 61 | 6d 70 6c 65 20 73 63 72 |ded a sa|mple scr|
|000005f0| 69 70 74 2c 20 61 73 20 | 77 65 6c 6c 20 61 73 20 |ipt, as |well as |
|00000600| 61 20 73 61 6d 70 6c 65 | 20 71 75 65 72 79 20 64 |a sample| query d|
|00000610| 6f 63 75 6d 65 6e 74 20 | 74 68 61 74 20 75 73 65 |ocument |that use|
|00000620| 73 20 44 41 4c 2e 20 20 | 54 68 69 73 20 73 61 6d |s DAL. |This sam|
|00000630| 70 6c 65 20 72 65 74 72 | 69 65 76 65 73 20 64 61 |ple retr|ieves da|
|00000640| 74 61 20 66 72 6f 6d 20 | 74 68 65 20 44 41 4c 44 |ta from |the DALD|
|00000650| 45 4d 4f 20 64 61 74 61 | 62 61 73 65 2c 20 77 68 |EMO data|base, wh|
|00000660| 69 63 68 20 69 73 20 69 | 6e 63 6c 75 64 65 64 20 |ich is i|ncluded |
|00000670| 77 69 74 68 20 65 76 65 | 72 79 20 72 65 6c 65 61 |with eve|ry relea|
|00000680| 73 65 20 6f 66 20 44 41 | 4c 2e 20 20 54 6f 20 75 |se of DA|L. To u|
|00000690| 73 65 20 74 68 65 20 73 | 61 6d 70 6c 65 2c 20 74 |se the s|ample, t|
|000006a0| 68 65 20 63 6f 6e 6e 65 | 63 74 69 6f 6e 20 69 6e |he conne|ction in|
|000006b0| 66 6f 72 6d 61 74 69 6f | 6e 20 69 6e 20 74 68 65 |formatio|n in the|
|000006c0| 20 71 75 65 72 79 20 64 | 6f 63 75 6d 65 6e 74 20 | query d|ocument |
|000006d0| 77 69 6c 6c 20 68 61 76 | 65 20 74 6f 20 62 65 20 |will hav|e to be |
|000006e0| 63 68 61 6e 67 65 64 20 | 74 6f 20 72 65 66 6c 65 |changed |to refle|
|000006f0| 63 74 20 74 68 65 20 6c | 6f 63 61 6c 20 63 6f 6e |ct the l|ocal con|
|00000700| 66 69 67 75 72 61 74 69 | 6f 6e 2e 00 00 00 00 00 |figurati|on......|
|00000710| 00 24 00 03 00 02 01 16 | 6f bc 01 16 72 b0 01 ac |.$......|o...r...|
|00000720| 01 09 01 16 71 e8 00 00 | 00 00 00 01 00 01 00 0f |....q...|........|
|00000730| 00 00 07 09 ff ff 00 00 | 00 24 00 02 00 10 00 0c |........|.$......|
|00000740| 00 03 00 00 00 00 00 00 | 00 00 00 00 00 01 00 13 |........|........|
|00000750| 00 0e 00 03 01 00 00 0e | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 8c 00 13 00 0e 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|00000770| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|00000780| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|00000790| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|000007a0| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|000007b0| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|000007c0| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|000007d0| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 10 |........|........|
|000007e0| 00 0c 00 10 00 0c 00 10 | 00 0c 00 10 00 0c 00 00 |........|........|
|000007f0| 00 08 00 00 00 00 01 16 | 7a cc 00 00 00 16 00 00 |........|z.......|
|00000800| 00 00 00 00 00 10 00 0c | 00 01 00 00 00 00 00 00 |........|........|
|00000810| 00 00 00 00 00 00 00 0c | 00 00 00 01 00 27 00 01 |........|.....'..|
|00000820| 01 50 02 20 | |.P. | |
+--------+-------------------------+-------------------------+--------+--------+